An error occurred within the web site, the details are as follows:
struct | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Cause |
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
DataSource | christopheralanhomes | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Detail | [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near 'Techster'. | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
ErrorCode | HY000 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Exceptions |
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Message | Error Executing Database Query. | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
NativeErrorCode | 102 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
RootCause |
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
SQLState | HY000 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Sql | SELECT DISTINCT A.ID, A.Title, A.Date, A.ShortDescription, A.PDF, A.PDFTitle, A.HomePage, A.Display, A.AuthorName, A.ParentID, a.MetaTitle, a.Metadescription, SmallImage, SmallImageAltTag,BlogRows,HideCommenting, SmallImageTitleTag, A.ArticleLink, A.SiteCode ,detail1 ,image1 ,imageAltTag1 ,Video1 ,ImageLocation1 ,imageTitleTag1 ,detail2 ,image2 ,imageAltTag2 ,Video2 ,ImageLocation2 ,imageTitleTag2 ,detail3 ,image3 ,imageAltTag3 ,Video3 ,ImageLocation3 ,imageTitleTag3 ,detail4 ,image4 ,imageAltTag4 ,Video4 ,ImageLocation4 ,imageTitleTag4 ,detail5 ,image5 ,imageAltTag5 ,Video5 ,ImageLocation5 ,imageTitleTag5 ,detail6 ,image6 ,imageAltTag6 ,Video6 ,ImageLocation6 ,imageTitleTag6 ,detail7 ,image7 ,imageAltTag7 ,Video7 ,ImageLocation7 ,imageTitleTag7 ,detail8 ,image8 ,imageAltTag8 ,Video8 ,ImageLocation8 ,imageTitleTag8 ,detail9 ,image9 ,imageAltTag9 ,Video9 ,ImageLocation9 ,imageTitleTag9 ,detail10 ,image10 ,imageAltTag10 ,Video10 ,ImageLocation10 ,imageTitleTag10 FROM Blog AS A INNER JOIN BlogCategory AS B ON (',' + a.ParentID + ',' LIKE '%,' + CAST(list/6330 Techster Blvd. AS nvarchar) + ',%') WHERE (A.Display = 1) AND A.SiteCode = 'CAH' ORDER BY A.Date DESC, title | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
StackTrace | coldfusion.tagext.sql.QueryTag$DatabaseQueryException: Error Executing Database Query. at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:867) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:769) at cfqry_getAllArticles2ecfm1361845362.runPage(D:\CustomDomains\ChristopherAlanHomes\htdocs\sNews\qry_getAllArticles.cfm:41) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:247) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:736) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:572) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:3011) at cfindex2ecfm685109944.runPage(D:\CustomDomains\ChristopherAlanHomes\htdocs\sNews\index.cfm:31) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:247) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:736) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:572) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:3011) at cfindex2ecfm333492098.runPage(D:\CustomDomains\ChristopherAlanHomes\htdocs\index.cfm:19) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:247) at coldfusion.filter.CFVariablesScopeFilter.invoke(CFVariablesScopeFilter.java:56) at coldfusion.tagext.lang.ModuleTag.doStartTag(ModuleTag.java:332) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:3011) at cf4042ecfm2058209091.runPage(D:\CustomDomains\ChristopherAlanHomes\htdocs\404.cfm:88) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:247) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:736) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:572) at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65) at coldfusion.filter.IpFilter.invoke(IpFilter.java:45) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:495) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:42) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:153) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:94) at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:78) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:58) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:62) at coldfusion.CfmServlet.service(CfmServlet.java:219) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:219) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:110) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:494) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:458) at org.apache.coyote.ajp.AjpProcessor.process(AjpProcessor.java:196) at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:637) at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Thread.java:748) Caused by: java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near 'Techster'. at macromedia.jdbc.sqlserverbase.ddcw.b(Unknown Source) at macromedia.jdbc.sqlserverbase.ddcw.a(Unknown Source) at macromedia.jdbc.sqlserverbase.ddcv.b(Unknown Source) at macromedia.jdbc.sqlserverbase.ddcv.a(Unknown Source) at macromedia.jdbc.sqlserver.tds.ddr.v(Unknown Source) at macromedia.jdbc.sqlserver.tds.ddr.a(Unknown Source) at macromedia.jdbc.sqlserver.tds.ddr.c(Unknown Source) at macromedia.jdbc.sqlserver.dda3.m(Unknown Source) at macromedia.jdbc.sqlserverbase.dde7.e(Unknown Source) at macromedia.jdbc.sqlserverbase.dde7.a(Unknown Source) at macromedia.jdbc.sqlserverbase.dde7.x(Unknown Source) at macromedia.jdbc.sqlserverbase.dde7.t(Unknown Source) at macromedia.jdbc.sqlserverbase.dde7.execute(Unknown Source) at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:359) at coldfusion.sql.Executive.executeQuery(Executive.java:1485) at coldfusion.sql.Executive.executeQuery(Executive.java:1235) at coldfusion.sql.Executive.executeQuery(Executive.java:1165) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:406) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1187) at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:816) ... 56 more | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Suppressed |
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
TagContext |
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Type | Database | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
queryError | [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near 'Techster'. | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
where | [empty string] |
struct [empty] |
---|
struct | |
---|---|
404;https://christopheralanhomes.com:443/press/news-article-list/6330 Techster Blvd. | [empty string] |
struct | |||
---|---|---|---|
favorites |
|
||
loggedin | [empty string] | ||
sessionid | CF771F5B08E711BA7EF5D3C063E71395.cfusion | ||
urltoken | CFID=79923738&CFTOKEN=7ceab4da35cc2b8-9CAE95DC-916E-FAD2-1628C6997F12CE8C&jsessionid=CF771F5B08E711BA7EF5D3C063E71395.cfusion | ||
userid | [empty string] |
struct | |
---|---|
AUTH_PASSWORD | [empty string] |
AUTH_TYPE | [empty string] |
AUTH_USER | [empty string] |
CERT_COOKIE | [empty string] |
CERT_FLAGS | [empty string] |
CERT_ISSUER | [empty string] |
CERT_KEYSIZE | 256 |
CERT_SECRETKEYSIZE | 2048 |
CERT_SERIALNUMBER | [empty string] |
CERT_SERVER_ISSUER | C=US, O=DigiCert Inc, OU=www.digicert.com, CN=RapidSSL TLS RSA CA G1 |
CERT_SERVER_SUBJECT | CN=*.ChristopherAlanHomes.com |
CERT_SUBJECT | [empty string] |
CF_TEMPLATE_PATH | D:\CustomDomains\ChristopherAlanHomes\htdocs\404.cfm |
CONTENT_LENGTH | 0 |
CONTENT_TYPE | [empty string] |
CONTEXT_PATH | [empty string] |
GATEWAY_INTERFACE | CGI/1.1 |
HTTPS | on |
HTTPS_KEYSIZE | 256 |
HTTPS_SECRETKEYSIZE | 2048 |
HTTPS_SERVER_ISSUER | C=US, O=DigiCert Inc, OU=www.digicert.com, CN=RapidSSL TLS RSA CA G1 |
HTTPS_SERVER_SUBJECT | CN=*.ChristopherAlanHomes.com |
HTTP_ACCEPT | */* |
HTTP_ACCEPT_ENCODING | [empty string] |
HTTP_ACCEPT_LANGUAGE | [empty string] |
HTTP_CONNECTION | [empty string] |
HTTP_COOKIE | [empty string] |
HTTP_HOST | christopheralanhomes.com |
HTTP_REFERER | [empty string] |
HTTP_URL | [empty string] |
HTTP_USER_AGENT | Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com) |
LOCAL_ADDR | 192.168.10.157 |
PATH_INFO | [empty string] |
PATH_TRANSLATED | D:\CustomDomains\ChristopherAlanHomes\htdocs\404.cfm |
QUERY_STRING | 404;https://christopheralanhomes.com:443/press/news-article-list/6330 Techster Blvd. |
REMOTE_ADDR | 192.168.10.245 |
REMOTE_HOST | 192.168.10.245 |
REMOTE_USER | [empty string] |
REQUEST_METHOD | GET |
SCRIPT_NAME | /404.cfm |
SERVER_NAME | christopheralanhomes.com |
SERVER_PORT | 443 |
SERVER_PORT_SECURE | 1 |
SERVER_PROTOCOL | HTTP/1.1 |
SERVER_SOFTWARE | Microsoft-IIS/10.0 |
WEB_SERVER_API | [empty string] |